Overview

Dataset info

Number of variables62
Number of observations90697
Missing cells832241 (14.8%)
Duplicate rows0 (0.0%)
Total size in memory165.3 MiB
Average record size in memory1.9 KiB

Variables types

CAT37
NUM16
BOOL8
DATE1

Reproduction info

Date of analysis2020-05-04 09:29:50.839084
Versionpandas-profiling v2.4.0
Command linepandas_profiling --config_file config.yaml [YOUR_FILE.csv]
Download Configurationconfig.yaml

Warnings

Alternative_purchasing_group has 3542 (3.9%) missing values Missing
Alternative_purchasing_group has a high cardinality: 561 distinct values Warning
ATC has a high cardinality: 1111 distinct values Warning
Chemical_/_biological has 7621 (8.4%) missing values Missing
consumption has 7514 (8.3%) zeros Zeros
consumption_previous_year has 3745 (4.1%) zeros Zeros
Current_consumption has 8480 (9.3%) zeros Zeros
Dangerous_material_is_charged_with_a_permit has 80310 (88.5%) missing values Missing
dangerous_substance has 80326 (88.6%) missing values Missing
Date_of_basket_entry has 41213 (45.4%) missing values Missing
Date_of_basket_entry has a high cardinality: 54 distinct values Warning
Description_Alternative_purchasing_group has 3542 (3.9%) missing values Missing
Description_Alternative_purchasing_group has a high cardinality: 561 distinct values Warning
Description_outline has 6891 (7.6%) missing values Missing
Description_outline has a high cardinality: 306 distinct values Warning
European_patent_expires has 89409 (98.6%) missing values Missing
For_adults has 86837 (95.7%) missing values Missing
Form_of_giving has 52945 (58.4%) missing values Missing
GENERY_FATHER has 53724 (59.2%) missing values Missing
GENERY_FATHER has a high cardinality: 680 distinct values Warning
Inventory has 10370 (11.4%) zeros Zeros
Inventory_of_consumption_months has 32934 (36.3%) zeros Zeros
Main_outline has 6891 (7.6%) missing values Missing
Main_outline has a high cardinality: 306 distinct values Warning
Narcotic_/_psychotropic has 41313 (45.6%) missing values Missing
Narcotic_/_psychotropic has 46358 (51.1%) zeros Zeros
Plant has constant value "7350.0" Rejected
Prediction has 8934 (9.9%) zeros Zeros
Price_for_absolute_packaging has 1324 (1.5%) zeros Zeros
Quantity_in_absolute_packaging has 1324 (1.5%) zeros Zeros
Quantity_in_Packaging-Absolute has 1324 (1.5%) zeros Zeros
Quantity_in_packing-relative has 64712 (71.3%) zeros Zeros
Safety_Stock has 9502 (10.5%) zeros Zeros
Send_code_to_Omri has constant value "1.0" Rejected
Serving_form has 7904 (8.7%) missing values Missing
Serving_form has a high cardinality: 53 distinct values Warning
skucode2 has a high cardinality: 3207 distinct values Warning
status has constant value "1.0" Rejected
Toxic_item has 7362 (8.1%) missing values Missing
type_of_packeging has 85285 (94.0%) missing values Missing
U#S#_Patent_Expires has 89166 (98.3%) missing values Missing
Validity_of_Ministry_of_Health_registration has 86155 (95.0%) missing values Missing
Validity_of_Ministry_of_Health_registration has a high cardinality: 83 distinct values Warning
VENDOR has a high cardinality: 155 distinct values Warning
Current_consumption is highly correlated with consumption and 3 other fieldsHigh Correlation
consumption is highly correlated with Current_consumption and 2 other fieldsHigh Correlation
General_purpose_ is highly correlated with General_purposeHigh Correlation
General_purpose is highly correlated with General_purpose_High Correlation
Inventory is highly correlated with Current_consumption and 1 other fieldsHigh Correlation
Prediction is highly correlated with consumption and 2 other fieldsHigh Correlation
Quantity_in_Packaging-Absolute is highly correlated with Quantity_in_absolute_packagingHigh Correlation
Quantity_in_absolute_packaging is highly correlated with Quantity_in_Packaging-AbsoluteHigh Correlation
Safety_Stock is highly correlated with consumption and 3 other fieldsHigh Correlation
General_purpose_ is highly correlated with General_purposeHigh Correlation
General_purpose is highly correlated with General_purpose_High Correlation
month_year_ is highly correlated with month_yearHigh Correlation
month_year is highly correlated with month_year_High Correlation
Volume_marker is highly correlated with Budget_GroupHigh Correlation
Budget_Group is highly correlated with Volume_markerHigh Correlation

Variables

Distinct count38
Unique (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size708.6 KiB
20190
14723
20100
11235
20120
9449
20130
 
7744
20210
 
5920
Other values (33)
41626
ValueCountFrequency (%) 
20190 14723 16.2%
 
20100 11235 12.4%
 
20120 9449 10.4%
 
20130 7744 8.5%
 
20210 5920 6.5%
 
20140 5192 5.7%
 
20270 4324 4.8%
 
20220 3800 4.2%
 
20180 3707 4.1%
 
20110 3031 3.3%
 
Other values (28) 21572 23.8%
 

Composition

Contains charsFalse
Contains digitsTrue
Contains whitespaceFalse
Contains non-wordsFalse

Length

Max length5
Mean length4.996063817
Min length4
Scatter

ABC
Categorical

Distinct count3
Unique (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size708.6 KiB
C
49485
B
30334
A
10878
ValueCountFrequency (%) 
C 49485 54.6%
 
B 30334 33.4%
 
A 10878 12.0%
 

Composition

Contains charsTrue
Contains digitsFalse
Contains whitespaceFalse
Contains non-wordsFalse

Length

Max length1
Mean length1
Min length1
Scatter
Distinct count39
Unique (%)< 0.1%
Missing147
Missing (%)0.2%
Memory size708.6 KiB
20
14504
11
11556
13
9668
24
9137
14
8010
Other values (33)
37675
ValueCountFrequency (%) 
20 14504 16.0%
 
11 11556 12.7%
 
13 9668 10.7%
 
24 9137 10.1%
 
14 8010 8.8%
 
21 6052 6.7%
 
15 5254 5.8%
 
22 4072 4.5%
 
19 3955 4.4%
 
17 2889 3.2%
 
Other values (28) 15453 17.0%
 

Composition

Contains charsTrue
Contains digitsTrue
Contains whitespaceFalse
Contains non-wordsFalse

Length

Max length4
Mean length2.003241563
Min length2
Scatter

Alternative_purchasing_group
Categorical

MISSING
HIGH CARDINALITY
Distinct count561
Unique (%)0.6%
Missing3542
Missing (%)3.9%
Memory size708.6 KiB
1734
 
2963
1591
 
1889
1875
 
1705
1068
 
1515
1823
 
1352
Other values (555)
77731
ValueCountFrequency (%) 
1734 2963 3.3%
 
1591 1889 2.1%
 
1875 1705 1.9%
 
1068 1515 1.7%
 
1823 1352 1.5%
 
1317 1309 1.4%
 
1053 1217 1.3%
 
1642 1027 1.1%
 
1027 965 1.1%
 
1354 952 1.0%
 
Other values (550) 72261 79.7%
 
(Missing) 3542 3.9%
 

Composition

Contains charsTrue
Contains digitsTrue
Contains whitespaceFalse
Contains non-wordsFalse

Length

Max length4
Mean length4
Min length4
Scatter

ATC
Categorical

HIGH CARDINALITY
Distinct count1111
Unique (%)1.2%
Missing0
Missing (%)0.0%
Memory size708.6 KiB
1/0/1900
 
6714
ATC:
 
1096
ATC:M01AE01
 
887
ATC:C10AA07
 
631
ATC:C10AA05
 
622
Other values (1106)
80747
ValueCountFrequency (%) 
1/0/1900 6714 7.4%
 
ATC: 1096 1.2%
 
ATC:M01AE01 887 1.0%
 
ATC:C10AA07 631 0.7%
 
ATC:C10AA05 622 0.7%
 
ATC:N03AX16 618 0.7%
 
ATC:A11AA06 611 0.7%
 
ATC:N06BA04 587 0.6%
 
ATC:A11CC05 545 0.6%
 
ATC:A07FA01 531 0.6%
 
Other values (1101) 77855 85.8%
 

Composition

Contains charsTrue
Contains digitsTrue
Contains whitespaceFalse
Contains non-wordsTrue

Length

Max length11
Mean length10.53277396
Min length4
Scatter
Distinct count5
Unique (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size708.6 KiB
EA
75965
PAC
 
14365
KIT
 
321
BLS
 
24
BT
 
22
ValueCountFrequency (%) 
EA 75965 83.8%
 
PAC 14365 15.8%
 
KIT 321 0.4%
 
BLS 24 < 0.1%
 
BT 22 < 0.1%
 

Composition

Contains charsTrue
Contains digitsFalse
Contains whitespaceFalse
Contains non-wordsFalse

Length

Max length3
Mean length2.162188386
Min length2
Scatter

Budget_Group
Categorical

HIGH CORRELATION
Distinct count5
Unique (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size708.6 KiB
B
43242
E
23065
A
18708
D
 
5580
H
 
102
ValueCountFrequency (%) 
B 43242 47.7%
 
E 23065 25.4%
 
A 18708 20.6%
 
D 5580 6.2%
 
H 102 0.1%
 

Composition

Contains charsTrue
Contains digitsFalse
Contains whitespaceFalse
Contains non-wordsFalse

Length

Max length1
Mean length1
Min length1
Scatter

Chemical_/_biological
Categorical

MISSING
Distinct count3
Unique (%)< 0.1%
Missing7621
Missing (%)8.4%
Memory size708.6 KiB
1
80095
2
 
2981
ValueCountFrequency (%) 
1 80095 88.3%
 
2 2981 3.3%
 
(Missing) 7621 8.4%
 

Composition

Contains charsTrue
Contains digitsTrue
Contains whitespaceFalse
Contains non-wordsTrue

Length

Max length3
Mean length3
Min length3
Scatter

chronic
Boolean

Distinct count3
Unique (%)< 0.1%
Missing428
Missing (%)0.5%
Memory size708.6 KiB
0
51192
1
39077
(Missing)
 
428
ValueCountFrequency (%) 
0 51192 56.4%
 
1 39077 43.1%
 
(Missing) 428 0.5%
 
Distinct count3
Unique (%)< 0.1%
Missing1
Missing (%)< 0.1%
Memory size708.6 KiB
ave
74914
pred
15782
ValueCountFrequency (%) 
ave 74914 82.6%
 
pred 15782 17.4%
 
(Missing) 1 < 0.1%
 

Composition

Contains charsTrue
Contains digitsFalse
Contains whitespaceFalse
Contains non-wordsFalse

Length

Max length4
Mean length3.174018986
Min length3
Scatter

consumption
Real number (ℝ≥0)

ZEROS
HIGH CORRELATION
Distinct count2224
Unique (%)2.5%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean8.276880129
Minimum0.0
Maximum15.29536379352081
Zeros7514
Zeros (%)8.3%
Memory size708.6 KiB
Mini histogram

Quantile statistics

Minimum0
5-th percentile0
Q16.720220155
median8.45616849
Q310.76534322
95-th percentile12.8376263
Maximum15.29536379
Range15.29536379
Interquartile range (IQR)4.045123063

Descriptive statistics

Standard deviation3.381153499
Coefficient of variation (CV)0.4085057953
Kurtosis0.6698103026
Mean8.276880129
Median Absolute Deviation (MAD)2.571665816
Skewness-0.8771061145
Sum750688.1971
Variance11.43219899
Histogram
Histogram with fixed size bins (bins=10)
Histogram
Histogram with variable size bins (bins=[ 0. 0.34657359 1.58902692 1.93560051 2.24990484 ... 14.10343288 14.25162119 14.29273439 15.00291843 15.29536379], "bayesian blocks" binning strategy used)
ValueCountFrequency (%) 
0 7514 8.3%
 
6.933423026 133 0.1%
 
7.001245622 126 0.1%
 
5.953243334 121 0.1%
 
10.21431226 120 0.1%
 
7.794823152 118 0.1%
 
8.646289765 117 0.1%
 
6.520621128 116 0.1%
 
11.82188701 113 0.1%
 
7.071573364 110 0.1%
 
Other values (2214) 82109 90.5%
 
ValueCountFrequency (%) 
0 7514 8.3%
 
0.6931471806 25 < 0.1%
 
1.098612289 20 < 0.1%
 
1.386294361 16 < 0.1%
 
1.791759469 2 < 0.1%
 
ValueCountFrequency (%) 
15.29536379 60 0.1%
 
15.01487305 60 0.1%
 
14.99096382 60 0.1%
 
14.30600347 60 0.1%
 
14.2794653 60 0.1%
 

consumption_previous_year
Real number (ℝ≥0)

ZEROS
Distinct count2755
Unique (%)3.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean887840.7473
Minimum0.0
Maximum46044870.0
Zeros3745
Zeros (%)4.1%
Memory size708.6 KiB
Mini histogram

Quantile statistics

Minimum0
5-th percentile735.4
Q111172
median62310
Q3598950
95-th percentile4533600
Maximum46044870
Range46044870
Interquartile range (IQR)587778

Descriptive statistics

Standard deviation2701115.98
Coefficient of variation (CV)3.042342885
Kurtosis98.28656155
Mean887840.7473
Median Absolute Deviation (MAD)1208727.411
Skewness8.102139676
Sum8.052449226e+10
Variance7.296027539e+12
Histogram
Histogram with fixed size bins (bins=10)
Histogram
Histogram with variable size bins (bins=[0.0000000e+00 5.0000000e-01 2.0000000e+00 6.5000000e+00 1.1500000e+01 ... 1.5478775e+07 1.6305360e+07 1.8004425e+07 3.6691470e+07 4.6044870e+07], "bayesian blocks" binning strategy used)
ValueCountFrequency (%) 
0 3745 4.1%
 
12687 106 0.1%
 
9622 94 0.1%
 
11371 87 0.1%
 
5770 83 0.1%
 
17716 83 0.1%
 
4532 79 0.1%
 
454770 79 0.1%
 
3530 70 0.1%
 
8341 62 0.1%
 
Other values (2745) 86209 95.1%
 
ValueCountFrequency (%) 
0 3745 4.1%
 
1 59 0.1%
 
3 3 < 0.1%
 
10 50 0.1%
 
13 2 < 0.1%
 
ValueCountFrequency (%) 
46044870 60 0.1%
 
37611900 60 0.1%
 
35771040 60 0.1%
 
19037280 60 0.1%
 
16971570 60 0.1%
 

Current_consumption
Real number (ℝ≥0)

ZEROS
HIGH CORRELATION
Distinct count2212
Unique (%)2.4%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean8.423440842
Minimum0.0
Maximum15.55008061287187
Zeros8480
Zeros (%)9.3%
Memory size708.6 KiB
Mini histogram

Quantile statistics

Minimum0
5-th percentile0
Q16.877296071
median8.674367866
Q311.04756703
95-th percentile13.16260472
Maximum15.55008061
Range15.55008061
Interquartile range (IQR)4.170270959

Descriptive statistics

Standard deviation3.563217731
Coefficient of variation (CV)0.4230121393
Kurtosis0.5559346564
Mean8.423440842
Median Absolute Deviation (MAD)2.704257467
Skewness-0.9017921421
Sum763980.8141
Variance12.6965206
Histogram
Histogram with fixed size bins (bins=10)
Histogram
Histogram with variable size bins (bins=[ 0. 0.34657359 0.89587973 1.24245332 1.86883481 ... 14.33295878 14.35070898 14.49566592 15.2724364 15.55008061], "bayesian blocks" binning strategy used)
ValueCountFrequency (%) 
0 8480 9.3%
 
8.118505068 154 0.2%
 
4.795790546 151 0.2%
 
6.931471806 147 0.2%
 
6.401917197 142 0.2%
 
5.198497031 137 0.2%
 
6.638567789 129 0.1%
 
6.583409222 119 0.1%
 
8.246695944 118 0.1%
 
7.245655068 117 0.1%
 
Other values (2202) 81003 89.3%
 
ValueCountFrequency (%) 
0 8480 9.3%
 
0.6931471806 1 < 0.1%
 
1.098612289 77 0.1%
 
1.386294361 26 < 0.1%
 
1.609437912 10 < 0.1%
 
ValueCountFrequency (%) 
15.55008061 60 0.1%
 
15.28981603 60 0.1%
 
15.25505678 60 0.1%
 
14.51385471 60 0.1%
 
14.47747714 60 0.1%
 
Distinct count3
Unique (%)< 0.1%
Missing80310
Missing (%)88.5%
Memory size708.6 KiB
0
10058
1
 
329
ValueCountFrequency (%) 
0 10058 11.1%
 
1 329 0.4%
 
(Missing) 80310 88.5%
 

Composition

Contains charsTrue
Contains digitsTrue
Contains whitespaceFalse
Contains non-wordsFalse

Length

Max length4
Mean length3.656427445
Min length1
Scatter

dangerous_substance
Categorical

MISSING
Distinct count3
Unique (%)< 0.1%
Missing80326
Missing (%)88.6%
Memory size708.6 KiB
0
9727
1
 
644
ValueCountFrequency (%) 
0 9727 10.7%
 
1 644 0.7%
 
(Missing) 80326 88.6%
 

Composition

Contains charsTrue
Contains digitsTrue
Contains whitespaceFalse
Contains non-wordsFalse

Length

Max length4
Mean length3.65695668
Min length1
Scatter

Date_of_basket_entry
Categorical

MISSING
HIGH CARDINALITY
Distinct count54
Unique (%)0.1%
Missing41213
Missing (%)45.4%
Memory size708.6 KiB
01.01.1995
23781
01.01.2000
 
4298
01.03.2001
 
3333
01.03.1999
 
2760
01.03.2002
 
2118
Other values (48)
13194
ValueCountFrequency (%) 
01.01.1995 23781 26.2%
 
01.01.2000 4298 4.7%
 
01.03.2001 3333 3.7%
 
01.03.1999 2760 3.0%
 
01.03.2002 2118 2.3%
 
01.01.2009 1418 1.6%
 
01.05.2006 1402 1.5%
 
01.03.2008 1070 1.2%
 
15.01.2015 853 0.9%
 
01.01.2010 790 0.9%
 
Other values (43) 7661 8.4%
 
(Missing) 41213 45.4%
 

Composition

Contains charsTrue
Contains digitsTrue
Contains whitespaceFalse
Contains non-wordsTrue

Length

Max length10
Mean length7.273581265
Min length4
Scatter

Description_Alternative_purchasing_group
Categorical

MISSING
HIGH CARDINALITY
Distinct count561
Unique (%)0.6%
Missing3542
Missing (%)3.9%
Memory size708.6 KiB
Hypertension
 
2963
Bact.Inf., Sys.
 
1889
Statines
 
1705
EPILEPSY- Anticonvulsants
 
1515
Pain, Mod/Sev
 
1352
Other values (555)
77731
ValueCountFrequency (%) 
Hypertension 2963 3.3%
 
Bact.Inf., Sys. 1889 2.1%
 
Statines 1705 1.9%
 
EPILEPSY- Anticonvulsants 1515 1.7%
 
Pain, Mod/Sev 1352 1.5%
 
הורדת חום ושיכוך כאב 1309 1.4%
 
Depression-SSRI 1217 1.3%
 
Diabetes Mell. 1027 1.1%
 
BPH 965 1.1%
 
טיפול אנטי פטרייתי 952 1.0%
 
Other values (550) 72261 79.7%
 
(Missing) 3542 3.9%
 

Composition

Contains charsTrue
Contains digitsTrue
Contains whitespaceTrue
Contains non-wordsTrue

Length

Max length30
Mean length15.21452749
Min length2
Scatter

Description_outline
Categorical

MISSING
HIGH CARDINALITY
Distinct count306
Unique (%)0.3%
Missing6891
Missing (%)7.6%
Memory size708.6 KiB
Hypertension
 
3180
Diabetes Mell.
 
3005
food adittive
 
2471
Not Designated
 
2361
Epilepsy
 
2016
Other values (300)
70773
ValueCountFrequency (%) 
Hypertension 3180 3.5%
 
Diabetes Mell. 3005 3.3%
 
food adittive 2471 2.7%
 
Not Designated 2361 2.6%
 
Epilepsy 2016 2.2%
 
Bact.Inf., Sys. 1893 2.1%
 
cosmetics 1868 2.1%
 
Statines 1705 1.9%
 
Antidepressants 1683 1.9%
 
Pain, Mild/Mod. 1602 1.8%
 
Other values (295) 62022 68.4%
 
(Missing) 6891 7.6%
 

Composition

Contains charsTrue
Contains digitsTrue
Contains whitespaceTrue
Contains non-wordsTrue

Length

Max length30
Mean length12.00066154
Min length3
Scatter

df_index
Real number (ℝ≥0)

UNIQUE
Distinct count90697
Unique (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean54602.10858
Minimum0
Maximum109199
Zeros1
Zeros (%)< 0.1%
Memory size708.6 KiB
Mini histogram

Quantile statistics

Minimum0
5-th percentile5442.8
Q127270
median54644
Q381884
95-th percentile103723.2
Maximum109199
Range109199
Interquartile range (IQR)54614

Descriptive statistics

Standard deviation31526.67024
Coefficient of variation (CV)0.5773892449
Kurtosis-1.200406177
Mean54602.10858
Median Absolute Deviation (MAD)27307.16505
Skewness-0.001034537182
Sum4952247442
Variance993930936.5
Histogram
Histogram with fixed size bins (bins=10)
Histogram
Histogram with variable size bins (bins=[ 0. 109199.], "bayesian blocks" binning strategy used)
ValueCountFrequency (%) 
6141 1 < 0.1%
 
101028 1 < 0.1%
 
60104 1 < 0.1%
 
58057 1 < 0.1%
 
64202 1 < 0.1%
 
62155 1 < 0.1%
 
49869 1 < 0.1%
 
56014 1 < 0.1%
 
8913 1 < 0.1%
 
15058 1 < 0.1%
 
Other values (90687) 90687 > 99.9%
 
ValueCountFrequency (%) 
0 1 < 0.1%
 
1 1 < 0.1%
 
2 1 < 0.1%
 
4 1 < 0.1%
 
5 1 < 0.1%
 
ValueCountFrequency (%) 
109199 1 < 0.1%
 
109198 1 < 0.1%
 
109197 1 < 0.1%
 
109196 1 < 0.1%
 
109195 1 < 0.1%
 
Distinct count879
Unique (%)1.0%
Missing0
Missing (%)0.0%
Memory size708.6 KiB
Minimum2006-03-06 00:00:00
Maximum2019-08-19 00:00:00
Mini histogram
Histogram
Histogram

European_patent_expires
Categorical

MISSING
Distinct count30
Unique (%)< 0.1%
Missing89409
Missing (%)98.6%
Memory size708.6 KiB
01.02.2015
168
01.06.2017
 
99
01.03.2016
 
98
01.10.2018
 
96
01.03.2017
 
81
Other values (24)
746
ValueCountFrequency (%) 
01.02.2015 168 0.2%
 
01.06.2017 99 0.1%
 
01.03.2016 98 0.1%
 
01.10.2018 96 0.1%
 
01.03.2017 81 0.1%
 
01.09.2019 65 0.1%
 
01.12.2022 61 0.1%
 
01.05.2020 60 0.1%
 
01.07.2018 59 0.1%
 
01.05.2019 53 0.1%
 
Other values (19) 448 0.5%
 
(Missing) 89409 98.6%
 

Composition

Contains charsTrue
Contains digitsTrue
Contains whitespaceFalse
Contains non-wordsTrue

Length

Max length10
Mean length4.085206787
Min length4
Scatter
Distinct count2
Unique (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size708.6 KiB
0
81017
1
 
9680
ValueCountFrequency (%) 
0 81017 89.3%
 
1 9680 10.7%
 

For_adults
Categorical

MISSING
Distinct count2
Unique (%)< 0.1%
Missing86837
Missing (%)95.7%
Memory size708.6 KiB
1
3860
ValueCountFrequency (%) 
1 3860 4.3%
 
(Missing) 86837 95.7%
 

Composition

Contains charsTrue
Contains digitsTrue
Contains whitespaceFalse
Contains non-wordsFalse

Length

Max length4
Mean length3.872322128
Min length1
Scatter

Form_of_giving
Categorical

MISSING
Distinct count4
Unique (%)< 0.1%
Missing52945
Missing (%)58.4%
Memory size708.6 KiB
0
37724
17
 
22
15
 
6
ValueCountFrequency (%) 
0 37724 41.6%
 
17 22 < 0.1%
 
15 6 < 0.1%
 
(Missing) 52945 58.4%
 

Composition

Contains charsTrue
Contains digitsTrue
Contains whitespaceFalse
Contains non-wordsFalse

Length

Max length4
Mean length2.751579435
Min length1
Scatter

General_purpose
Categorical

HIGH CORRELATION
HIGH CORRELATION
Distinct count4
Unique (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size708.6 KiB
0
89272
6
 
842
2
 
378
1
 
205
ValueCountFrequency (%) 
0 89272 98.4%
 
6 842 0.9%
 
2 378 0.4%
 
1 205 0.2%
 

Composition

Contains charsFalse
Contains digitsTrue
Contains whitespaceFalse
Contains non-wordsTrue

Length

Max length3
Mean length3
Min length3
Scatter

General_purpose_
Categorical

HIGH CORRELATION
HIGH CORRELATION
Distinct count4
Unique (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size708.6 KiB
0
89272
6
 
842
2
 
378
1
 
205
ValueCountFrequency (%) 
0 89272 98.4%
 
6 842 0.9%
 
2 378 0.4%
 
1 205 0.2%
 

Composition

Contains charsFalse
Contains digitsTrue
Contains whitespaceFalse
Contains non-wordsTrue

Length

Max length3
Mean length3
Min length3
Scatter

GENERY_FATHER
Categorical

MISSING
HIGH CARDINALITY
Distinct count680
Unique (%)0.7%
Missing53724
Missing (%)59.2%
Memory size708.6 KiB
3999001541
 
186
3999001291
 
179
3999019172
 
178
3999001511
 
177
3999001491
 
176
Other values (674)
36077
ValueCountFrequency (%) 
3999001541 186 0.2%
 
3999001291 179 0.2%
 
3999019172 178 0.2%
 
3999001511 177 0.2%
 
3999001491 176 0.2%
 
3999001490 174 0.2%
 
3999001542 171 0.2%
 
3999001150 171 0.2%
 
3999003522 167 0.2%
 
3999001280 165 0.2%
 
Other values (669) 35229 38.8%
 
(Missing) 53724 59.2%
 

Composition

Contains charsTrue
Contains digitsTrue
Contains whitespaceFalse
Contains non-wordsFalse

Length

Max length10
Mean length6.445924341
Min length4
Scatter

Inventory
Real number (ℝ≥0)

ZEROS
HIGH CORRELATION
Distinct count2253
Unique (%)2.5%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean8.347757278
Minimum0.0
Maximum15.681570278478281
Zeros10370
Zeros (%)11.4%
Memory size708.6 KiB
Mini histogram

Quantile statistics

Minimum0
5-th percentile0
Q17.132497552
median8.650149419
Q311.09363016
95-th percentile13.09956751
Maximum15.68157028
Range15.68157028
Interquartile range (IQR)3.961132607

Descriptive statistics

Standard deviation3.687010887
Coefficient of variation (CV)0.4416768198
Kurtosis0.5326076753
Mean8.347757278
Median Absolute Deviation (MAD)2.729885759
Skewness-0.9806135714
Sum757116.5418
Variance13.59404928
Histogram
Histogram with fixed size bins (bins=10)
Histogram
Histogram with variable size bins (bins=[ 0. 0.54930614 1.44518588 2.13833306 2.60200334 ... 14.71652487 14.75657529 14.94675861 15.67182292 15.68157028], "bayesian blocks" binning strategy used)
ValueCountFrequency (%) 
0 10370 11.4%
 
6.775366091 130 0.1%
 
5.993961427 120 0.1%
 
8.567696174 120 0.1%
 
8.802071337 120 0.1%
 
8.896588072 120 0.1%
 
7.700295203 117 0.1%
 
10.63135012 116 0.1%
 
11.21682136 115 0.1%
 
7.843064017 114 0.1%
 
Other values (2243) 79255 87.4%
 
ValueCountFrequency (%) 
0 10370 11.4%
 
1.098612289 8 < 0.1%
 
1.791759469 59 0.1%
 
1.945910149 32 < 0.1%
 
2.079441542 13 < 0.1%
 
ValueCountFrequency (%) 
15.68157028 60 0.1%
 
15.66207555 60 0.1%
 
15.09810996 60 0.1%
 
14.79540725 60 0.1%
 
14.71774334 60 0.1%
 

Inventory_of_consumption_months
Real number (ℝ≥0)

ZEROS
Distinct count32
Unique (%)< 0.1%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean0.6161149977
Minimum0.0
Maximum6.668228248417403
Zeros32934
Zeros (%)36.3%
Memory size708.6 KiB
Mini histogram

Quantile statistics

Minimum0
5-th percentile0
Q10
median0.6931471806
Q31.098612289
95-th percentile1.386294361
Maximum6.668228248
Range6.668228248
Interquartile range (IQR)1.098612289

Descriptive statistics

Standard deviation0.5586083026
Coefficient of variation (CV)0.9066624002
Kurtosis3.50920502
Mean0.6161149977
Median Absolute Deviation (MAD)0.4474487874
Skewness0.8964444332
Sum55879.78195
Variance0.3120432357
Histogram
Histogram with fixed size bins (bins=10)
Histogram
Histogram with variable size bins (bins=[0. 0.34657359 0.89587973 1.24245332 1.49786614 ... 3.17718502 3.27554017 3.49466763 5.26439203 6.66822825], "bayesian blocks" binning strategy used)
ValueCountFrequency (%) 
0 32934 36.3%
 
0.6931471806 30986 34.2%
 
1.098612289 16412 18.1%
 
1.386294361 6882 7.6%
 
1.609437912 1739 1.9%
 
1.791759469 626 0.7%
 
1.945910149 244 0.3%
 
2.079441542 157 0.2%
 
2.197224577 121 0.1%
 
2.397895273 104 0.1%
 
Other values (22) 492 0.5%
 
ValueCountFrequency (%) 
0 32934 36.3%
 
0.6931471806 30986 34.2%
 
1.098612289 16412 18.1%
 
1.386294361 6882 7.6%
 
1.609437912 1739 1.9%
 
ValueCountFrequency (%) 
6.668228248 6 < 0.1%
 
5.545177444 2 < 0.1%
 
4.983606622 18 < 0.1%
 
4.700480366 15 < 0.1%
 
4.59511985 21 < 0.1%
 
Distinct count3
Unique (%)< 0.1%
Missing155
Missing (%)0.2%
Memory size708.6 KiB
1
56296
0
34246
(Missing)
 
155
ValueCountFrequency (%) 
1 56296 62.1%
 
0 34246 37.8%
 
(Missing) 155 0.2%
 

Item_Type
Categorical

Distinct count5
Unique (%)< 0.1%
Missing405
Missing (%)0.4%
Memory size708.6 KiB
0
89920
1
 
252
6
 
60
3
 
60
ValueCountFrequency (%) 
0 89920 99.1%
 
1 252 0.3%
 
6 60 0.1%
 
3 60 0.1%
 
(Missing) 405 0.4%
 

Composition

Contains charsTrue
Contains digitsTrue
Contains whitespaceFalse
Contains non-wordsTrue

Length

Max length3
Mean length3
Min length3
Scatter

Loading_group
Categorical

Distinct count12
Unique (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size708.6 KiB
23
78836
11
 
3303
25
 
2814
13
 
1700
24
 
1186
Other values (7)
 
2858
ValueCountFrequency (%) 
23 78836 86.9%
 
11 3303 3.6%
 
25 2814 3.1%
 
13 1700 1.9%
 
24 1186 1.3%
 
12 839 0.9%
 
22 748 0.8%
 
15 595 0.7%
 
14 333 0.4%
 
19 206 0.2%
 
Other values (2) 137 0.2%
 

Composition

Contains charsFalse
Contains digitsTrue
Contains whitespaceFalse
Contains non-wordsFalse

Length

Max length2
Mean length1.998544605
Min length1
Scatter

Main_outline
Categorical

MISSING
HIGH CARDINALITY
Distinct count306
Unique (%)0.3%
Missing6891
Missing (%)7.6%
Memory size708.6 KiB
13
 
3180
12
 
3005
393
 
2471
0
 
2361
14
 
2016
Other values (300)
70773
ValueCountFrequency (%) 
13 3180 3.5%
 
12 3005 3.3%
 
393 2471 2.7%
 
0 2361 2.6%
 
14 2016 2.2%
 
60 1893 2.1%
 
392 1868 2.1%
 
432 1705 1.9%
 
420 1683 1.9%
 
54 1602 1.8%
 
Other values (295) 62022 68.4%
 
(Missing) 6891 7.6%
 

Composition

Contains charsTrue
Contains digitsTrue
Contains whitespaceFalse
Contains non-wordsFalse

Length

Max length4
Mean length2.558805694
Min length1
Scatter

Material_Type
Categorical

Distinct count3
Unique (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size708.6 KiB
ZHW1
83757
ZHW3
 
6697
ZUB1
 
243
ValueCountFrequency (%) 
ZHW1 83757 92.3%
 
ZHW3 6697 7.4%
 
ZUB1 243 0.3%
 

Composition

Contains charsTrue
Contains digitsTrue
Contains whitespaceFalse
Contains non-wordsFalse

Length

Max length4
Mean length4
Min length4
Scatter

month_year
Categorical

HIGH CORRELATION
Distinct count30
Unique (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size708.6 KiB
07/2018
 
3186
01/2019
 
3150
08/2018
 
3131
10/2018
 
3127
07/2019
 
3114
Other values (25)
74989
ValueCountFrequency (%) 
07/2018 3186 3.5%
 
01/2019 3150 3.5%
 
08/2018 3131 3.5%
 
10/2018 3127 3.4%
 
07/2019 3114 3.4%
 
01/2018 3107 3.4%
 
10/2017 3087 3.4%
 
05/2018 3086 3.4%
 
09/2019 3085 3.4%
 
03/2019 3082 3.4%
 
Other values (20) 59542 65.6%
 

Composition

Contains charsFalse
Contains digitsTrue
Contains whitespaceFalse
Contains non-wordsTrue

Length

Max length7
Mean length7
Min length7
Scatter

month_year_
Categorical

HIGH CORRELATION
Distinct count30
Unique (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size708.6 KiB
07/2018
 
3186
01/2019
 
3150
08/2018
 
3131
10/2018
 
3127
07/2019
 
3114
Other values (25)
74989
ValueCountFrequency (%) 
07/2018 3186 3.5%
 
01/2019 3150 3.5%
 
08/2018 3131 3.5%
 
10/2018 3127 3.4%
 
07/2019 3114 3.4%
 
01/2018 3107 3.4%
 
10/2017 3087 3.4%
 
05/2018 3086 3.4%
 
09/2019 3085 3.4%
 
03/2019 3082 3.4%
 
Other values (20) 59542 65.6%
 

Composition

Contains charsFalse
Contains digitsTrue
Contains whitespaceFalse
Contains non-wordsTrue

Length

Max length7
Mean length7
Min length7
Scatter
Distinct count3
Unique (%)< 0.1%
Missing56
Missing (%)0.1%
Memory size708.6 KiB
1
57411
0
33230
(Missing)
 
56
ValueCountFrequency (%) 
1 57411 63.3%
 
0 33230 36.6%
 
(Missing) 56 0.1%
 

Narcotic_/_psychotropic
Real number (ℝ≥0)

MISSING
ZEROS
Distinct count6
Unique (%)< 0.1%
Missing41313
Missing (%)45.6%
Infinite0
Infinite (%)0.0%
Mean0.1018751012
Minimum0.0
Maximum5.0
Zeros46358
Zeros (%)51.1%
Memory size708.6 KiB
Mini histogram

Quantile statistics

Minimum0
5-th percentile0
Q10
median0
Q30
95-th percentile1
Maximum5
Range5
Interquartile range (IQR)0

Descriptive statistics

Standard deviation0.4602865691
Coefficient of variation (CV)4.518145881
Kurtosis39.7921035
Mean0.1018751012
Median Absolute Deviation (MAD)0.1912654278
Skewness5.756198531
Sum5031
Variance0.2118637257
Histogram
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
0 46358 51.1%
 
1 1700 1.9%
 
2 839 0.9%
 
3 391 0.4%
 
5 96 0.1%
 
(Missing) 41313 45.6%
 
ValueCountFrequency (%) 
0 46358 51.1%
 
1 1700 1.9%
 
2 839 0.9%
 
3 391 0.4%
 
5 96 0.1%
 
ValueCountFrequency (%) 
5 96 0.1%
 
3 391 0.4%
 
2 839 0.9%
 
1 1700 1.9%
 
0 46358 51.1%
 

Plant
Categorical

CONST
Distinct count1
Unique (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size708.6 KiB
7350
90697
ValueCountFrequency (%) 
7350 90697 100.0%
 

Composition

Contains charsFalse
Contains digitsTrue
Contains whitespaceFalse
Contains non-wordsTrue

Length

Max length6
Mean length6
Min length6
Scatter

Prediction
Real number (ℝ≥0)

ZEROS
HIGH CORRELATION
Distinct count2163
Unique (%)2.4%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean8.140049537
Minimum0.0
Maximum15.2747725806165
Zeros8934
Zeros (%)9.9%
Memory size708.6 KiB
Mini histogram

Quantile statistics

Minimum0
5-th percentile0
Q16.613384218
median8.387312271
Q310.73832959
95-th percentile12.80583454
Maximum15.27477258
Range15.27477258
Interquartile range (IQR)4.12494537

Descriptive statistics

Standard deviation3.506519381
Coefficient of variation (CV)0.4307737152
Kurtosis0.4705409472
Mean8.140049537
Median Absolute Deviation (MAD)2.66813448
Skewness-0.8677243096
Sum738278.0729
Variance12.29567817
Histogram
Histogram with fixed size bins (bins=10)
Histogram
Histogram with variable size bins (bins=[ 0. 0.34657359 1.86883481 2.67355377 2.83148024 ... 14.03102027 14.07667623 14.27130931 14.9147953 15.27477258], "bayesian blocks" binning strategy used)
ValueCountFrequency (%) 
0 8934 9.9%
 
6.442540166 159 0.2%
 
6.144185634 141 0.2%
 
7.290974778 139 0.2%
 
7.166265974 137 0.2%
 
6.156978986 130 0.1%
 
6.395261598 125 0.1%
 
8.839856233 120 0.1%
 
8.239065332 120 0.1%
 
8.487970333 120 0.1%
 
Other values (2153) 80572 88.8%
 
ValueCountFrequency (%) 
0 8934 9.9%
 
0.6931471806 2 < 0.1%
 
1.386294361 1 < 0.1%
 
1.609437912 1 < 0.1%
 
1.791759469 1 < 0.1%
 
ValueCountFrequency (%) 
15.27477258 60 0.1%
 
14.94489451 60 0.1%
 
14.8846961 60 0.1%
 
14.28658923 60 0.1%
 
14.25602938 60 0.1%
 

PRICE
Real number (ℝ≥0)

Distinct count1453
Unique (%)1.6%
Missing4
Missing (%)< 0.1%
Infinite0
Infinite (%)0.0%
Mean1.856337958
Minimum0.009950330853168092
Maximum9.48095970022173
Zeros0
Zeros (%)0.0%
Memory size708.6 KiB
Mini histogram

Quantile statistics

Minimum0.009950330853
5-th percentile0.1310282624
Q10.3920420878
median1.757857918
Q32.857618971
95-th percentile4.380149875
Maximum9.4809597
Range9.471009369
Interquartile range (IQR)2.465576884

Descriptive statistics

Standard deviation1.516207124
Coefficient of variation (CV)0.8167732161
Kurtosis0.8650471867
Mean1.856337958
Median Absolute Deviation (MAD)1.259478842
Skewness0.8631057827
Sum168356.8584
Variance2.298884044
Histogram
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
0.1310282624 1143 1.3%
 
0.1484200051 893 1.0%
 
0.1397619424 881 1.0%
 
0.2851789422 873 1.0%
 
0.1823215568 862 1.0%
 
0.2546422184 854 0.9%
 
0.1043600153 846 0.9%
 
0.4121096508 762 0.8%
 
2.541601993 733 0.8%
 
0.0953101798 715 0.8%
 
Other values (1442) 82131 90.6%
 
ValueCountFrequency (%) 
0.009950330853 173 0.2%
 
0.02955880224 195 0.2%
 
0.03922071315 151 0.2%
 
0.04879016417 210 0.2%
 
0.05826890812 177 0.2%
 
ValueCountFrequency (%) 
9.4809597 1 < 0.1%
 
9.431307156 28 < 0.1%
 
9.256069666 4 < 0.1%
 
9.145556487 5 < 0.1%
 
9.015209525 2 < 0.1%
 

Price_for_absolute_packaging
Real number (ℝ≥0)

ZEROS
Distinct count1846
Unique (%)2.0%
Missing4
Missing (%)< 0.1%
Infinite0
Infinite (%)0.0%
Mean3.388497516
Minimum0.0
Maximum10.807915397787752
Zeros1324
Zeros (%)1.5%
Memory size708.6 KiB
Mini histogram

Quantile statistics

Minimum0
5-th percentile1.16938136
Q12.151762203
median2.85532012
Q34.281791849
95-th percentile7.335086244
Maximum10.8079154
Range10.8079154
Interquartile range (IQR)2.130029646

Descriptive statistics

Standard deviation1.857490182
Coefficient of variation (CV)0.548175164
Kurtosis0.645013535
Mean3.388497516
Median Absolute Deviation (MAD)1.448163948
Skewness0.9846069822
Sum307313.0052
Variance3.450269775
Histogram
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
0 1324 1.5%
 
1.757857918 1074 1.2%
 
1.648658626 922 1.0%
 
2.541601993 649 0.7%
 
2.791165108 635 0.7%
 
1.458615023 611 0.7%
 
2.272125886 599 0.7%
 
1.945910149 583 0.6%
 
1.902107526 481 0.5%
 
1.386294361 480 0.5%
 
Other values (1835) 83335 91.9%
 
ValueCountFrequency (%) 
0 1324 1.5%
 
0.02955880224 52 0.1%
 
0.06765864847 60 0.1%
 
0.08617769624 75 0.1%
 
0.0953101798 179 0.2%
 
ValueCountFrequency (%) 
10.8079154 4 < 0.1%
 
10.62652188 1 < 0.1%
 
10.46598376 5 < 0.1%
 
10.32333606 1 < 0.1%
 
10.20502815 7 < 0.1%
 

Pure_OTC
Boolean

Distinct count2
Unique (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size708.6 KiB
0
67205
1
23492
ValueCountFrequency (%) 
0 67205 74.1%
 
1 23492 25.9%
 

Quantity_in_absolute_packaging
Real number (ℝ≥0)

ZEROS
HIGH CORRELATION
Distinct count54
Unique (%)0.1%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean2.359293924
Minimum0.0
Maximum6.1070228877422545
Zeros1324
Zeros (%)1.5%
Memory size708.6 KiB
Mini histogram

Quantile statistics

Minimum0
5-th percentile0.6931471806
Q10.6931471806
median3.044522438
Q33.433987204
95-th percentile4.510859507
Maximum6.107022888
Range6.107022888
Interquartile range (IQR)2.740840024

Descriptive statistics

Standard deviation1.438830906
Coefficient of variation (CV)0.6098565726
Kurtosis-1.565341213
Mean2.359293924
Median Absolute Deviation (MAD)1.345052332
Skewness-0.1025959404
Sum213980.881
Variance2.070234377
Histogram
Histogram with fixed size bins (bins=10)
Histogram
Histogram with variable size bins (bins=[0. 0.34657359 0.89587973 1.49786614 1.70059869 ... 5.31315744 5.33743406 5.38397927 5.79804012 6.10702289], "bayesian blocks" binning strategy used)
ValueCountFrequency (%) 
0.6931471806 32341 35.7%
 
3.433987204 20321 22.4%
 
3.36729583 6078 6.7%
 
4.110873864 4679 5.2%
 
3.044522438 4570 5.0%
 
4.615120517 3030 3.3%
 
2.397895273 2182 2.4%
 
3.931825633 2030 2.2%
 
1.791759469 1623 1.8%
 
4.043051268 1516 1.7%
 
Other values (44) 12327 13.6%
 
ValueCountFrequency (%) 
0 1324 1.5%
 
0.6931471806 32341 35.7%
 
1.098612289 1026 1.1%
 
1.386294361 663 0.7%
 
1.609437912 1165 1.3%
 
ValueCountFrequency (%) 
6.107022888 1 < 0.1%
 
5.993961427 36 < 0.1%
 
5.602118821 3 < 0.1%
 
5.416100402 3 < 0.1%
 
5.351858133 30 < 0.1%
 

Quantity_in_Packaging-Absolute
Real number (ℝ≥0)

ZEROS
HIGH CORRELATION
Distinct count54
Unique (%)0.1%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean2.359293924
Minimum0.0
Maximum6.1070228877422545
Zeros1324
Zeros (%)1.5%
Memory size708.6 KiB
Mini histogram

Quantile statistics

Minimum0
5-th percentile0.6931471806
Q10.6931471806
median3.044522438
Q33.433987204
95-th percentile4.510859507
Maximum6.107022888
Range6.107022888
Interquartile range (IQR)2.740840024

Descriptive statistics

Standard deviation1.438830906
Coefficient of variation (CV)0.6098565726
Kurtosis-1.565341213
Mean2.359293924
Median Absolute Deviation (MAD)1.345052332
Skewness-0.1025959404
Sum213980.881
Variance2.070234377
Histogram
Histogram with fixed size bins (bins=10)
Histogram
Histogram with variable size bins (bins=[0. 0.34657359 0.89587973 1.49786614 1.70059869 ... 5.31315744 5.33743406 5.38397927 5.79804012 6.10702289], "bayesian blocks" binning strategy used)
ValueCountFrequency (%) 
0.6931471806 32341 35.7%
 
3.433987204 20321 22.4%
 
3.36729583 6078 6.7%
 
4.110873864 4679 5.2%
 
3.044522438 4570 5.0%
 
4.615120517 3030 3.3%
 
2.397895273 2182 2.4%
 
3.931825633 2030 2.2%
 
1.791759469 1623 1.8%
 
4.043051268 1516 1.7%
 
Other values (44) 12327 13.6%
 
ValueCountFrequency (%) 
0 1324 1.5%
 
0.6931471806 32341 35.7%
 
1.098612289 1026 1.1%
 
1.386294361 663 0.7%
 
1.609437912 1165 1.3%
 
ValueCountFrequency (%) 
6.107022888 1 < 0.1%
 
5.993961427 36 < 0.1%
 
5.602118821 3 < 0.1%
 
5.416100402 3 < 0.1%
 
5.351858133 30 < 0.1%
 

Quantity_in_packing-relative
Real number (ℝ≥0)

ZEROS
Distinct count65
Unique (%)0.1%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean1.007643155
Minimum0.0
Maximum6.90875477931522
Zeros64712
Zeros (%)71.3%
Memory size708.6 KiB
Mini histogram

Quantile statistics

Minimum0
5-th percentile0
Q10
median0
Q31.791759469
95-th percentile4.795790546
Maximum6.908754779
Range6.908754779
Interquartile range (IQR)1.791759469

Descriptive statistics

Standard deviation1.769177283
Coefficient of variation (CV)1.755757754
Kurtosis0.8673295359
Mean1.007643155
Median Absolute Deviation (MAD)1.443884889
Skewness1.507195845
Sum91390.21124
Variance3.129988259
Histogram
Histogram with fixed size bins (bins=10)
Histogram
Histogram with variable size bins (bins=[0. 0.34657359 0.89587973 1.24245332 1.49786614 ... 6.11588238 6.16845176 6.41900588 6.76508022 6.90875478], "bayesian blocks" binning strategy used)
ValueCountFrequency (%) 
0 64712 71.3%
 
2.772588722 3022 3.3%
 
4.615120517 2390 2.6%
 
2.397895273 2085 2.3%
 
3.931825633 1960 2.2%
 
3.433987204 1905 2.1%
 
1.791759469 1510 1.7%
 
3.044522438 1174 1.3%
 
1.386294361 1057 1.2%
 
6.216606101 992 1.1%
 
Other values (55) 9890 10.9%
 
ValueCountFrequency (%) 
0 64712 71.3%
 
0.6931471806 863 1.0%
 
1.098612289 803 0.9%
 
1.386294361 1057 1.2%
 
1.609437912 145 0.2%
 
ValueCountFrequency (%) 
6.908754779 115 0.1%
 
6.621405652 58 0.1%
 
6.216606101 992 1.1%
 
6.120297419 51 0.1%
 
6.11146734 121 0.1%
 

Safety_Stock
Real number (ℝ≥0)

ZEROS
HIGH CORRELATION
Distinct count2132
Unique (%)2.4%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean7.916702577
Minimum0.0
Maximum15.47226783919266
Zeros9502
Zeros (%)10.5%
Memory size708.6 KiB
Mini histogram

Quantile statistics

Minimum0
5-th percentile0
Q16.539585956
median8.04462628
Q310.61849407
95-th percentile12.59795594
Maximum15.47226784
Range15.47226784
Interquartile range (IQR)4.078908112

Descriptive statistics

Standard deviation3.492251393
Coefficient of variation (CV)0.4411244908
Kurtosis0.4302664641
Mean7.916702577
Median Absolute Deviation (MAD)2.630418858
Skewness-0.8254522068
Sum718021.1736
Variance12.19581979
Histogram
Histogram with fixed size bins (bins=10)
Histogram
Histogram with variable size bins (bins=[ 0. 0.34657359 1.70059869 2.01267585 2.13833306 ... 14.34143051 14.3858663 14.88945292 15.45804062 15.47226784], "bayesian blocks" binning strategy used)
ValueCountFrequency (%) 
0 9502 10.5%
 
7.119635638 136 0.1%
 
7.239214974 130 0.1%
 
6.135564891 126 0.1%
 
6.602587892 122 0.1%
 
7.493873887 121 0.1%
 
7.400009517 120 0.1%
 
10.8062066 120 0.1%
 
11.87214417 119 0.1%
 
11.31568112 119 0.1%
 
Other values (2122) 80082 88.3%
 
ValueCountFrequency (%) 
0 9502 10.5%
 
0.6931471806 19 < 0.1%
 
1.386294361 33 < 0.1%
 
1.609437912 1 < 0.1%
 
1.791759469 21 < 0.1%
 
ValueCountFrequency (%) 
15.47226784 60 0.1%
 
15.4438134 60 0.1%
 
15.00171636 60 0.1%
 
14.77718948 60 0.1%
 
14.633735 60 0.1%
 
Distinct count3
Unique (%)< 0.1%
Missing11
Missing (%)< 0.1%
Memory size708.6 KiB
no
76674
yes
 
14012
(Missing)
 
11
ValueCountFrequency (%) 
no 76674 84.5%
 
yes 14012 15.4%
 
(Missing) 11 < 0.1%
 

Send_code_to_Omri
Boolean

CONST
Distinct count1
Unique (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size708.6 KiB
1
90697
ValueCountFrequency (%) 
1 90697 100.0%
 

Serving_form
Categorical

MISSING
HIGH CARDINALITY
Distinct count53
Unique (%)0.1%
Missing7904
Missing (%)8.7%
Memory size708.6 KiB
TAB
37094
CAP
8375
CR
 
4923
COL
 
3135
CPL
 
2565
Other values (47)
26701
ValueCountFrequency (%) 
TAB 37094 40.9%
 
CAP 8375 9.2%
 
CR 4923 5.4%
 
COL 3135 3.5%
 
CPL 2565 2.8%
 
GEL 2051 2.3%
 
OIN 1977 2.2%
 
SOL 1789 2.0%
 
INJ 1639 1.8%
 
LIQ 1592 1.8%
 
Other values (42) 17653 19.5%
 
(Missing) 7904 8.7%
 

Composition

Contains charsTrue
Contains digitsFalse
Contains whitespaceFalse
Contains non-wordsFalse

Length

Max length4
Mean length3.03286768
Min length2
Scatter

skucode2
Categorical

HIGH CARDINALITY
Distinct count3207
Unique (%)3.5%
Missing0
Missing (%)0.0%
Memory size708.6 KiB
10000003319
 
60
10000003879
 
60
10000003587
 
60
10000002480
 
60
10000005211
 
60
Other values (3202)
90397
ValueCountFrequency (%) 
10000003319 60 0.1%
 
10000003879 60 0.1%
 
10000003587 60 0.1%
 
10000002480 60 0.1%
 
10000005211 60 0.1%
 
10000001921 60 0.1%
 
10000006604 60 0.1%
 
10000005414 60 0.1%
 
10000003112 60 0.1%
 
10000004649 60 0.1%
 
Other values (3197) 90097 99.3%
 

Composition

Contains charsFalse
Contains digitsTrue
Contains whitespaceFalse
Contains non-wordsFalse

Length

Max length11
Mean length11
Min length11
Scatter

Sourcing_source
Categorical

Distinct count2
Unique (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size708.6 KiB
ארץ
90143
חו"ל
 
554
ValueCountFrequency (%) 
ארץ 90143 99.4%
 
חו"ל 554 0.6%
 

Composition

Contains charsFalse
Contains digitsFalse
Contains whitespaceFalse
Contains non-wordsTrue

Length

Max length4
Mean length3.006108251
Min length3
Scatter

status
Boolean

CONST
Distinct count1
Unique (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size708.6 KiB
1
90697
ValueCountFrequency (%) 
1 90697 100.0%
 

storecode
Categorical

Distinct count2
Unique (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size708.6 KiB
3224
46054
3315
44643
ValueCountFrequency (%) 
3224 46054 50.8%
 
3315 44643 49.2%
 

Composition

Contains charsFalse
Contains digitsTrue
Contains whitespaceFalse
Contains non-wordsTrue

Length

Max length6
Mean length6
Min length6
Scatter

Toxic_item
Categorical

MISSING
Distinct count5
Unique (%)< 0.1%
Missing7362
Missing (%)8.1%
Memory size708.6 KiB
0
82932
1
 
333
3
 
55
2
 
15
ValueCountFrequency (%) 
0 82932 91.4%
 
1 333 0.4%
 
3 55 0.1%
 
2 15 < 0.1%
 
(Missing) 7362 8.1%
 

Composition

Contains charsTrue
Contains digitsTrue
Contains whitespaceFalse
Contains non-wordsTrue

Length

Max length3
Mean length3
Min length3
Scatter

TranQuantity
Real number (ℝ≥0)

Distinct count1943
Unique (%)2.1%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean3.280400313
Minimum0.0
Maximum9.455714972131714
Zeros447
Zeros (%)0.5%
Memory size708.6 KiB
Mini histogram

Quantile statistics

Minimum0
5-th percentile0.6931471806
Q11.386294361
median3.044522438
Q34.86753445
95-th percentile6.862967009
Maximum9.455714972
Range9.455714972
Interquartile range (IQR)3.481240089

Descriptive statistics

Standard deviation2.042961548
Coefficient of variation (CV)0.6227781227
Kurtosis-0.8975574893
Mean3.280400313
Median Absolute Deviation (MAD)1.772392933
Skewness0.4249804534
Sum297522.4672
Variance4.173691889
Histogram
Histogram with fixed size bins (bins=10)
Histogram
Histogram with variable size bins (bins=[0. 0.34657359 0.89587973 1.24245332 1.70059869 ... 8.45233405 8.79118137 8.94357094 9.26538751 9.45571497], "bayesian blocks" binning strategy used)
ValueCountFrequency (%) 
0.6931471806 10802 11.9%
 
1.098612289 7535 8.3%
 
1.386294361 5312 5.9%
 
1.609437912 4111 4.5%
 
4.110873864 3589 4.0%
 
3.433987204 3294 3.6%
 
1.791759469 2936 3.2%
 
1.945910149 2478 2.7%
 
4.795790546 2067 2.3%
 
4.510859507 1843 2.0%
 
Other values (1933) 46730 51.5%
 
ValueCountFrequency (%) 
0 447 0.5%
 
0.6931471806 10802 11.9%
 
1.098612289 7535 8.3%
 
1.386294361 5312 5.9%
 
1.609437912 4111 4.5%
 
ValueCountFrequency (%) 
9.455714972 2 < 0.1%
 
9.427143868 1 < 0.1%
 
9.412546252 1 < 0.1%
 
9.346705246 2 < 0.1%
 
9.329455853 1 < 0.1%
 

type_of_packeging
Categorical

MISSING
Distinct count7
Unique (%)< 0.1%
Missing85285
Missing (%)94.0%
Memory size708.6 KiB
BOX
3632
TUB
773
BOT
770
PKG
 
200
BAG
 
24
ValueCountFrequency (%) 
BOX 3632 4.0%
 
TUB 773 0.9%
 
BOT 770 0.8%
 
PKG 200 0.2%
 
BAG 24 < 0.1%
 
KIT 13 < 0.1%
 
(Missing) 85285 94.0%
 

Composition

Contains charsTrue
Contains digitsFalse
Contains whitespaceFalse
Contains non-wordsFalse

Length

Max length4
Mean length3.940328787
Min length3
Scatter

U#S#_Patent_Expires
Categorical

MISSING
Distinct count33
Unique (%)< 0.1%
Missing89166
Missing (%)98.3%
Memory size708.6 KiB
01.03.2016
 
132
01.02.2018
 
117
01.10.2020
 
113
01.07.2018
 
107
01.10.2018
 
96
Other values (27)
966
ValueCountFrequency (%) 
01.03.2016 132 0.1%
 
01.02.2018 117 0.1%
 
01.10.2020 113 0.1%
 
01.07.2018 107 0.1%
 
01.10.2018 96 0.1%
 
01.05.2020 86 0.1%
 
01.03.2017 81 0.1%
 
01.12.2019 71 0.1%
 
01.03.2020 66 0.1%
 
01.06.2018 65 0.1%
 
Other values (22) 597 0.7%
 
(Missing) 89166 98.3%
 

Composition

Contains charsTrue
Contains digitsTrue
Contains whitespaceFalse
Contains non-wordsTrue

Length

Max length10
Mean length4.101282292
Min length4
Scatter

Validity_of_Ministry_of_Health_registration
Categorical

MISSING
HIGH CARDINALITY
Distinct count83
Unique (%)0.1%
Missing86155
Missing (%)95.0%
Memory size708.6 KiB
28.02.2015
 
250
30.04.2015
 
247
30.11.2012
 
244
30.11.2013
 
181
31.01.2007
 
180
Other values (77)
3440
ValueCountFrequency (%) 
28.02.2015 250 0.3%
 
30.04.2015 247 0.3%
 
30.11.2012 244 0.3%
 
30.11.2013 181 0.2%
 
31.01.2007 180 0.2%
 
30.09.2012 142 0.2%
 
31.10.2013 120 0.1%
 
31.03.2015 119 0.1%
 
31.01.2008 113 0.1%
 
31.05.2014 113 0.1%
 
Other values (72) 2833 3.1%
 
(Missing) 86155 95.0%
 

Composition

Contains charsTrue
Contains digitsTrue
Contains whitespaceFalse
Contains non-wordsTrue

Length

Max length10
Mean length4.300473004
Min length4
Scatter

VENDOR
Categorical

HIGH CARDINALITY
Distinct count155
Unique (%)0.2%
Missing594
Missing (%)0.7%
Memory size708.6 KiB
400059
 
8701
400057
 
4983
408668
 
4824
400095
 
4199
400045
 
3597
Other values (149)
63799
ValueCountFrequency (%) 
400059 8701 9.6%
 
400057 4983 5.5%
 
408668 4824 5.3%
 
400095 4199 4.6%
 
400045 3597 4.0%
 
406885 3543 3.9%
 
407214 2828 3.1%
 
400026 2778 3.1%
 
410232 2705 3.0%
 
400032 2203 2.4%
 
Other values (144) 49742 54.8%
 

Composition

Contains charsTrue
Contains digitsTrue
Contains whitespaceFalse
Contains non-wordsFalse

Length

Max length6
Mean length5.986901441
Min length4
Scatter

volume
Real number (ℝ≥0)

Distinct count1928
Unique (%)2.1%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean3.888156056
Minimum0.0
Maximum9.207736986106068
Zeros53
Zeros (%)0.1%
Memory size708.6 KiB
Mini histogram

Quantile statistics

Minimum0
5-th percentile1.404134279
Q11.978653888
median4.428433007
Q35.504652444
95-th percentile6.609349243
Maximum9.207736986
Range9.207736986
Interquartile range (IQR)3.525998556

Descriptive statistics

Standard deviation1.885215396
Coefficient of variation (CV)0.4848610419
Kurtosis-1.432567435
Mean3.888156056
Median Absolute Deviation (MAD)1.739452825
Skewness0.03042931426
Sum352644.0899
Variance3.554037091
Histogram
Histogram with fixed size bins (bins=10)
Histogram
Histogram with variable size bins (bins=[0. 0.10187842 0.61129619 0.70308526 0.72315728 ... 8.36082047 8.37848851 8.40416404 8.7215198 9.20773699], "bayesian blocks" binning strategy used)
ValueCountFrequency (%) 
1.496717042 614 0.7%
 
1.504077397 516 0.6%
 
1.489076556 452 0.5%
 
1.602816036 413 0.5%
 
5.198497031 400 0.4%
 
2.120223535 344 0.4%
 
1.526056303 323 0.4%
 
2.208274414 320 0.4%
 
2.014903021 318 0.4%
 
4.605170186 311 0.3%
 
Other values (1918) 86686 95.6%
 
ValueCountFrequency (%) 
0 53 0.1%
 
0.2037568375 2 < 0.1%
 
0.5754891371 12 < 0.1%
 
0.6471032421 60 0.1%
 
0.6981347221 12 < 0.1%
 
ValueCountFrequency (%) 
9.207736986 2 < 0.1%
 
9.019058794 11 < 0.1%
 
8.42398081 60 0.1%
 
8.384347278 17 < 0.1%
 
8.37262974 54 0.1%
 

Volume_marker
Categorical

HIGH CORRELATION
Distinct count5
Unique (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size708.6 KiB
B
43242
E
23065
A
18708
D
 
5580
H
 
102
ValueCountFrequency (%) 
B 43242 47.7%
 
E 23065 25.4%
 
A 18708 20.6%
 
D 5580 6.2%
 
H 102 0.1%
 

Composition

Contains charsTrue
Contains digitsFalse
Contains whitespaceFalse
Contains non-wordsFalse

Length

Max length1
Mean length1
Min length1
Scatter

Correlations

Missing values

Sample

First rows

A_group_of_materialsABCAffiliation_GroupAlternative_purchasing_groupATCBasic_unit_of_measureBudget_GroupChemical_/_biologicalchronicConsumer_managementconsumptionconsumption_previous_yearCurrent_consumptionDangerous_material_is_charged_with_a_permitdangerous_substanceDate_of_basket_entryDescription_Alternative_purchasing_groupDescription_outlinedf_indexEstablishment_date_of_the_itemEuropean_patent_expiresExceptional_policyFor_adultsForm_of_givingGeneral_purposeGeneral_purpose_GENERY_FATHERInventoryInventory_of_consumption_monthsItem_in_health_basketItem_TypeLoading_groupMain_outlineMaterial_Typemonth_yearmonth_year_Must_prescribeNarcotic_/_psychotropicPlantPredictionPRICEPrice_for_absolute_packagingPure_OTCQuantity_in_absolute_packagingQuantity_in_Packaging-AbsoluteQuantity_in_packing-relativeSafety_StockSeasonalitySend_code_to_OmriServing_formskucode2Sourcing_sourcestatusstorecodeToxic_itemTranQuantitytype_of_packegingU#S#_Patent_ExpiresValidity_of_Ministry_of_Health_registrationVENDORvolumeVolume_marker
020140B151180ATC:G03AA09PACB1.00.0ave8.75935583062.09.046880NoneNone01.04.2005Oral contraceptiveOral Contra.02006-03-06None0.0None00.00.0None9.0838700.6931471.00.023171ZHW103/201703/20171.00.07350.08.9027282.3379525.2860420.03.0910423.0910420.0000008.449343no1.0TAB10000005719ארץ1.03224.00.02.484907BOXNoneNone4086684.624973B
120190C201054ATC:N06AA04EAB1.01.0ave10.183049306420.010.460844NoneNone01.01.1995Depression-TricyclicAntidepressants12006-03-06None0.0None00.00.0399900542211.1353331.0986121.00.023420ZHW102/201902/20191.00.07350.010.1390730.1906201.9878740.03.4339873.4339870.00000010.342097no1.0TAB10000006427ארץ1.03224.00.04.795791NoneNoneNone4000951.554559B
220270C241351ATC:D08AX08EAE1.00.0ave7.18690113544.07.70571300Noneחיטוי ידייםcosmetics22016-05-18None0.0NoneNone0.00.0None6.7753660.0000000.00.023392ZHW107/201707/20170.0NaN7350.07.1163942.7107132.7107131.00.6931470.6931476.2166066.829794no1.0GEL10000001880ארץ1.03315.00.01.098612NoneNoneNone1242076.848005E
320180C191156ATC:M01AH01EAB1.00.0ave10.759476525410.010.990887NoneNoneNoneNSAIDS-COX 2 inhibtorsRheum. Arth.42006-03-06None0.0None00.00.0399901065511.3781480.6931470.00.02365ZHW102/201702/20171.00.07350.010.7226950.4446861.8870700.02.3978952.3978950.00000010.894125no1.0CAP10000006732ארץ1.03224.00.03.433987NoneNoneNone4000772.442347B
420120B131605ATC:C08CA01EAB1.01.0ave0.0000000.00.000000NoneNone01.01.2000Calcium Chanell BlockersCalcium Chanell Blockers52006-09-26None0.0NoneNone0.00.039990191720.0000000.0000001.00.023431ZHW104/201704/20171.00.07350.00.0000000.1310281.3350010.03.0445223.0445220.0000000.000000no1.0TAB10000004522ארץ1.03315.00.08.077447NoneNoneNone4000591.987874B
510150C72NoneZRP:102UB01EADNaN1.0ave0.0000000.00.000000NoneNone01.03.2001NoneNone62009-06-03None0.0NoneNone0.00.0None0.0000000.0000001.00.023NoneZHW303/201903/20191.0NaN7350.00.0000003.5213480.0000000.00.0000000.0000000.0000000.000000no1.0None10000003897ארץ1.03315.0NaN1.609438NoneNoneNone4000446.309236D
620220C221946ATC:S01XA30PACE1.00.0ave7.26543017751.07.524561NoneNoneNoneטיפות ליובש בעינייםArtificial Tears72010-12-27None0.0NoneNone0.00.0None7.9905771.0986120.00.023128ZHW105/201805/20180.0NaN7350.07.3072023.2861616.7149951.03.4965083.4965080.0000007.342779no1.0COL10000003478ארץ1.03315.00.02.397895NoneNoneNone4000066.226537E
720100B111354ATC:A01AB09EAB1.00.0ave8.15507539454.08.306472NoneNone01.01.1995טיפול אנטי פטרייתיFungal Inf, Oroph.82006-03-06None0.0None00.00.0None7.8284360.0000001.00.02383ZHW101/201801/20180.00.07350.08.0882552.6433342.6433340.00.6931470.6931473.7135727.462215no1.0GEL10000006295ארץ1.03315.00.01.609438NoneNone30.04.20121174695.370638B
810100C241429ZRP:A21ADEAENaN0.0ave6.2441675821.06.569481NoneNoneNoneסד תמיכה לידNone92006-03-06None0.0NoneNone0.00.0None7.1569561.0986120.00.023NoneZHW305/201805/20180.0NaN7350.06.1800173.4094963.4094961.00.6931470.6931470.0000006.410175no1.0None10000006992ארץ1.03224.0NaN1.098612NoneNoneNone4001236.651572E
920190C201017ATC:N07CA02EAB1.01.0ave12.1169302158850.012.316164NoneNone01.01.1995Antivertigo preparationsMeniere's Dis.112006-03-06None0.0None00.00.0None12.5401350.6931471.00.023209ZHW106/201706/20171.00.07350.012.0862640.1823221.7917590.03.2580973.2580970.00000011.760254no1.0TAB10000006644ארץ1.03224.00.06.356108NoneNone30.09.20124019742.151995B

Last rows

A_group_of_materialsABCAffiliation_GroupAlternative_purchasing_groupATCBasic_unit_of_measureBudget_GroupChemical_/_biologicalchronicConsumer_managementconsumptionconsumption_previous_yearCurrent_consumptionDangerous_material_is_charged_with_a_permitdangerous_substanceDate_of_basket_entryDescription_Alternative_purchasing_groupDescription_outlinedf_indexEstablishment_date_of_the_itemEuropean_patent_expiresExceptional_policyFor_adultsForm_of_givingGeneral_purposeGeneral_purpose_GENERY_FATHERInventoryInventory_of_consumption_monthsItem_in_health_basketItem_TypeLoading_groupMain_outlineMaterial_Typemonth_yearmonth_year_Must_prescribeNarcotic_/_psychotropicPlantPredictionPRICEPrice_for_absolute_packagingPure_OTCQuantity_in_absolute_packagingQuantity_in_Packaging-AbsoluteQuantity_in_packing-relativeSafety_StockSeasonalitySend_code_to_OmriServing_formskucode2Sourcing_sourcestatusstorecodeToxic_itemTranQuantitytype_of_packegingU#S#_Patent_ExpiresValidity_of_Ministry_of_Health_registrationVENDORvolumeVolume_marker
9068720130C141517ATC:D08AX01EAB1.0NaNave7.83002828150.08.131531NoneNone01.01.1995תכשיר לחיטויAntiseptic1091892014-08-24None0.0NoneNone0.00.0None8.1344680.6931471.00.023135ZHW102/201702/2017NaNNaN7350.07.7894551.4539531.4539530.00.6931470.6931474.6151217.473637no1.0SOL10000002477ארץ1.03315.00.01.098612NoneNoneNone4001715.894403B
9068820130C141519ATC:D02AC02EAE1.00.0pred6.8035059426.06.990257NoneNoneNoneתכשיר רחצה טיפולי - תינוקותDry Skin1091902010-06-09None0.0NoneNone0.00.0None7.3550020.6931470.00.025142ZHW106/201806/20180.0NaN7350.06.8585653.4384933.4384931.00.6931470.6931476.2166066.634633yes1.0OIL10000003622ארץ1.03315.00.01.098612NoneNoneNone4000446.893656E
9068920160A171651ATC:J07AJ52EAB2.00.0pred0.0000000.00.000000NoneNoneNoneDPT Vac.DPT Vac.1091912011-03-22None1.0NoneNone0.00.039990021400.0000000.0000001.00.01196ZHW101/201701/20171.0NaN7350.00.0000004.1616924.1616920.00.6931470.6931470.0000000.000000no1.0SRG10000003406ארץ1.03315.00.00.000000NoneNoneNone4001645.078917B
9069020240B241401ATC:V06DB15EAB1.00.0ave9.615872196110.09.891971NoneNone01.03.2008מזון ייעודיMetab. Disord.1091922014-11-04None0.0NoneNone0.00.0None9.2929340.0000001.00.025107ZHW104/201904/20190.0NaN7350.09.7011272.3035852.3035851.00.6931470.6931475.3981639.095715no1.0LIQ10000002408ארץ1.03315.00.04.110874NoneNoneNone4018826.144400B
9069120180B191076ATC:M04AC01EAB1.01.0ave13.0460465311080.013.336137NoneNone01.01.1995FMFGout1091932006-03-06None0.0None00.00.0None12.7310110.0000001.00.02375ZHW101/201701/20171.05.07350.013.0194040.3001052.4423470.03.4339873.4339870.00000012.352901no1.0TAB10000006474ארץ1.03224.00.07.170888NoneNoneNone4000451.369402B
9069220190C201823ATC:N02AA05EAB1.00.0ave6.5424728445.06.759255NoneNoneNonePain, Mod/SevPain, Mod/Sev1091952013-10-14None0.0NoneNone0.00.0None6.7007310.6931470.00.01359ZHW103/201803/20181.01.07350.06.5957813.5192773.5192770.00.6931470.6931473.4339876.658011no1.0SYR10000002704ארץ1.03315.00.01.609438NoneNoneNone4000455.129899B
9069320130C141352ATC:D08AG02EAB1.00.0pred8.71817374934.08.829226NoneNone01.01.1995חיטוי נגעים בעורAntiseptic1091962006-03-06None0.0None00.00.039990211508.5676960.0000001.00.023135ZHW103/201803/20180.00.07350.08.5020801.5062971.5062970.00.6931470.6931472.7725898.145550yes1.0OIN10000006784ארץ1.03315.00.02.995732NoneNoneNone4000574.934474B
9069420100C111375ATC:A07BB01EAB1.00.0ave11.155879637500.011.661699NoneNone01.01.1995טיפול בשלשול וכאב בטןDiarrhea1091972013-07-01None0.0NoneNone0.00.0399900254011.5125350.6931471.00.02347ZHW106/201906/20190.0NaN7350.010.8868200.2546421.9169230.03.0445223.0445220.00000011.313840no1.0TAB10000002793ארץ1.03315.00.05.484797NoneNoneNone4000261.953028B
9069520150C161694ATC:H02AB07EAB1.01.0ave12.0400241913000.012.307279NoneNone01.01.1995GlucocorticoidGlucocorticoid1091982006-03-06None0.0None00.00.0None12.2204730.6931471.00.023141ZHW109/201709/20171.00.07350.011.9958820.1397622.7725890.04.6151214.6151210.00000012.104544no1.0TAB10000006612ארץ1.03224.00.05.707110NoneNoneNone4000570.647103B
9069620220B221082ATC:S01EA05EAA1.01.0ave9.131622108414.09.398644NoneNone01.10.2005Glaucoma alpha 2 agonistGlaucoma1091992006-03-06None0.0None00.00.039990014448.7577840.0000001.00.02315ZHW109/201909/20191.00.07350.09.0806872.8553202.8553200.00.6931470.6931471.7917598.438583no1.0COL10000005869ארץ1.03315.00.03.713572NoneNoneNone4000364.418841A